Preferences Dialog

The Preferences Dialog provides a variety of CData Virtuality Studio configuration options. It has a navigation on the left with all the available settings pages:

• General
  • Notification management
• Server preferences
• Schema viewer
  • Colors
• SQL editor
• Optimizations view
• Job view

General

• Refresh status: sets the refreshing interval for Optimization and Job states
• Show system data sources: show or hide system data sources in the Data Explorer.
• Use '*' in generated SQL select statements: when checked, all the SQL select statements in Studio will contain wildcard ('*') instead of explicit list of columns.
• Tooltip activation policy:
  • Activate on double click
  • Activate on hover
• Detached Window Transparency setting changes transparency of detached tabs (gropus of tabs). The maximum value is 50%. The change is effective after re-opening or re-detaching the tabs.

General → Notification Management

CData Virtuality Studio has different confirmation dialogs, warnings and notices to inform the user or protect them from accidental actions. All those notifications are enabled by default, but can be skipped (disabled) using a check button next to the corresponding message dialog. Notifications can be re-enabled later from this page in the preferences.

Server Preferences

These are the low-level JDBC connection settings and server cleaner preferences.

JDBC connection settings:

• fetch size: Size of the resultset (default 500). A value <=0 indicates that the default should be used.
• auto commit: False = Do not wrap each command in a transaction. Individual source commands may commit or rollback regardless of the success or failure of the overall command. True = Wrap each command in a transaction. This mode is the safest, but may introduce performance overhead. DETECT = automatically wrap commands in a transaction, but only if the command seems to be transactionally unsafe.
• ansi quoted ids: Sets the parsing behavior for double quoted entries in SQL. The default, true, parses double quoted entries as identifiers. If set to false, then double quoted values that are valid string literals will be parsed as string literals.
• set result cache mode: turn ResultSet caching on/off. Default is false.
• show plan: DEBUG; ON returns the query plan along with the results. DEBUG additionally prints the query planner debug information in the log and returns it with the results. Default OFF.
• partial results mode: Enable/disable support for partial results mode. Default false.

The server cleaner is a system job on the server that cleans redundant materialized table stages from the Analytical Storage. Those are broken, incomplete or stale materialized tables that are not used by the server anymore. However, in some rare cases, those stage may be useful. The cleaner has an option that allows to retain the latest redundant stages for a while.

• Materialized table stages to keep: configures how many redundant stages will be kept. Max: 10 stages.
• How long to keep redundant stages (days): configures how long redundant stages will be kept. Max: 31 days.

Schema viewer

Set the options for the graphical representation in the Data source schema view

• Hide table columns: show / hide columns
• Don't truncate text in tables: abbreviate text with ... or show full text

The schema viewer in the table representation shows the list of table columns with all their detailed information, like type, nullable and so on. This preferences page shows the list of available column properties to show or hide.

Schema viewer → Colors

Set the colors for the graphical representation

SQL Editor

Set the options for the SQL editor

• Results page size: how many rows should be loaded at a time whens scrolling
• Query history size: how many queries should be saved in the history list
• Statement separator: statement separator string used to delimit individual SQL statements or queries
• Column width: sets result set table's column representation
• 'Count rows' and 'View Content' behavior: sets the behavior when clicking on 'Count rows' or 'View Content' of tables/views context menu
• Copy or export preferences : set the behavior of a table's context menu when copying or exporting.
  • Copy delimiter: sets a delimiter to be used between fields of a copied result set
  • Export separator: sets a separator to be used between fields of an exported result set
  • Include column headers during Export : sets the corresponding behavior during the export or while copying to clipboard.
  • Export newline as \n : sets the corresponding behavior during the export or while copying to clipboard.
  • Quote character : sets the actual quote character when the checkbox is selected.
• Default File name : sets the actual file name that has to be used while exporting the Result set
• Maximum copy size : sets the maximum size of the data in MBs that can be copied to the clipboard

Optimization view

Set the options for the Optimization View

Priorities for Recommended Optimizations are calculated as following. First all Recommended Optimizations are sorted by their frequency field. Then the list is divided into three parts:

• the a% of optimizations with the highest frequencies
• the b% of optimizations with the middle frequencies
• the c% of optimizations with the lowest frequencies

You can configure the percent values a, b and c in this preference page.

Job Run History

• Column width: sets the result set table's column representation in the Job History view